explain analyze select content from book_time_machine where content ~* 'dark' or content='darkness';

QUERY PLAN
Seq Scan on book_time_machine (cost=0.00..76.09 rows=21 width=456) (actual time=0.142..2.966 rows=39 loops=1)
Filter: ((content ~* 'dark'::text) OR (content = 'darkness'::text))
Rows Removed by Filter: 367
Total runtime: 2.987 ms

(4 rows)

explain analyze select content from book_time_machine where tsearch @@ to_tsquery('darkness');

QUERY PLAN
Bitmap Heap Scan on book_time_machine (cost=12.28..72.82 rows=36 width=456) (actual time=0.073..0.096 rows=36 loops=1)
Recheck Cond: (tsearch @@ to_tsquery('darkness'::text))
-> Bitmap Index Scan on time_mach_tsearch (cost=0.00..12.27 rows=36 width=0) (actual time=0.064..0.064 rows=36 loops=1)
Index Cond: (tsearch @@ to_tsquery('darkness'::text))
Total runtime: 0.128 ms

(5 rows)

explain analyze select content from book_heart_darkness where content ~* 'dark' or content='darkness';

QUERY PLAN
Seq Scan on book_heart_darkness (cost=0.00..52.03 rows=48 width=458) (actual time=0.205..3.526 rows=54 loops=1)
Filter: ((content ~* 'dark'::text) OR (content = 'darkness'::text))
Rows Removed by Filter: 215
Total runtime: 3.550 ms

(4 rows)

explain analyze select content from book_heart_darkness where tsearch @@ to_tsquery('darkness');

QUERY PLAN
Seq Scan on book_heart_darkness (cost=0.00..52.03 rows=53 width=458) (actual time=0.084..2.223 rows=53 loops=1)
Filter: (tsearch @@ to_tsquery('darkness'::text))
Rows Removed by Filter: 216
Total runtime: 2.243 ms

(4 rows)